Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources

Apache Calcite is a foundational software framework that provides query processing, optimization, and query language support to many popular open-source data processing systems such as Apache Hive, Apache Storm, Apache Flink, Druid, and MapD. Calcite's architecture consists of a modular and extensible query optimizer with hundreds of built-in optimization rules, a query processor capable of processing a variety of query languages, an adapter architecture designed for extensibility, and support for heterogeneous data models and stores (relational, semi-structured, streaming, and geospatial). This flexible, embeddable, and extensible architecture is what makes Calcite an attractive choice for adoption in big-data frameworks. It is an active project that continues to introduce support for the new types of data sources, query languages, and approaches to query processing and optimization.Comment: SIGMOD'1

The role of violent thinking in violent behaviour; it’s more about thinking than drinking

This article aims to explore and report on violent thinking and alcohol misuse; how these factors may predict self-reported violence. The role of violent thinking in violent behavior is both well established in theoretical models, yet there are few measures that explain this role. One measure that has been identified is the Maudsley Violence Questionnaire (MVQ). This is the first study to explore the use of the MVQ with a general (nonoffender) adult sample, having already been shown to be valid with young people (under 18 years old), adult male offenders, and mentally disordered offenders. This study involved 808 adult participants—569 female and 239 male participants. As figures demonstrate that around half of all violent crime in the United Kingdom is alcohol related, we also explored the role of alcohol misuse. Regression was used to explore how these factors predicted violence. The results demonstrate the important role of violent thinking in violent behavior. The MVQ factor of “Machismo” was the primary factor in regression models for both male and female self-reported violence. The role of alcohol in the regression models differed slightly between the male and female participants, with alcohol misuse involved in male violence. The study supports theoretical models including the role of violent thinking and encourages those hoping to address violence, to consider “Machismo” as a treatment target. The study also provides further validation of the MVQ as a helpful tool for clinicians or researchers who may be interested in “measuring” violent thinking

A directly comparative two-gate case–control diagnostic accuracy study of the pure tone screen and HearCheck screener tests for identifying hearing impairment in school children

Objectives: This study directly compared the accuracy of two audiometry-based tests for screening school children for hearing impairment: the currently used test, pure tone screen and a device newly applied to children, HearCheck Screener. Design: Two-gate case–control diagnostic test accuracy study. Setting and participants: Hearing impaired children (‘intended cases’) aged 4–6 years were recruited between February 2013 and August 2014 from collaborating audiology services. Children with no previously identified impairment (‘intended controls’) were recruited from Foundation and Year 1 of schools between February 2013 and June 2014 in central England. The reference standard was pure tone audiometry. Tests were administered at Nottingham Hearing Biomedical Research Unit or, for some intended cases only, in the participant’s home. Main outcome measures: Sensitivity and specificity of the pure tone screen and HearCheck tests based on pure tone audiometry result as reference standard. Results: 315 children (630 ears) were recruited; 75 from audiology services and 240 from schools. Full test and reference standard data were obtained for 600 ears; 155 ears were classified as truly impaired and 445 as truly hearing based on the pure tone audiometry assessment. Sensitivity was estimated to be 94.2% (95% CI 89.0% to 97.0%) for pure tone screen and 89.0% (95% CI 82.9% to 93.1%) for HearCheck (difference=5.2% favouring pure tone screen; 95% CI 0.2% to 10.1%; p=0.02). Estimates for specificity were 82.2% (95% CI 77.7% to 86.0%) for pure tone screen and 86.5% (95% CI 82.5% to 89.8%) for HearCheck (difference=4.3% favouring HearCheck; 95% CI0.4% to 8.2%; p=0.02). Conclusion: Pure tone screen was better than HearCheck with respect to sensitivity but inferior with respect to specificity. As avoiding missed cases is arguably of greater importance for school entry screening, pure tone screen is probably preferable in this context

Morphological and ecological convergence at the lower size limit for vertebrates highlighted by five new miniaturised microhylid frog species from three different Madagascan genera

Miniaturised frogs form a fascinating but poorly understood amphibian ecomorph and have been exceptionally prone to taxonomic underestimation. The subfamily Cophylinae (family Microhylidae), endemic to Madagascar, has a particularly large diversity of miniaturised species which have historically been attributed to the single genus Stumpffia largely based on their small size. Recent phylogenetic work has revealed that several independent lineages of cophyline microhylids evolved towards highly miniaturised body sizes, achieving adult snout- vent lengths under 16 mm. Here, we describe five new species belonging to three clades that independently miniaturised and that are all genetically highly divergent from their relatives: (i) a new genus (Mini gen.nov.) with three new species from southern Madagascar, (ii) one species of Rhombophryne, and (iii) one species of Anodonthyla. Mini mum sp. nov. from Manombo in eastern Madagascar is one of the smallest frogs in the world, reaching an adult body size of 9.7 mm in males and 11.3 mm in females. Mini scule sp.nov. from Sainte Luce in southeastern Madagascar is slightly larger and has maxillary teeth. Mini ature sp.nov. from Andohahela in southeast Madagascar is larger than its congeners but is similar in build. Rhombophryne proportionalis sp.nov. from Tsaratanana in northern Madagascar is unique among Madagascar's miniaturised frogs in being a proportional dwarf, exhibiting far less advanced signs of paedomorphism than other species of similar size. Anodonthyla eximia sp.nov. from Ranomafana in eastern Madagascar is distinctly smaller than any of its congeners and is secondarily terrestrial, providing evidence that miniaturisation and terrestriality may be evolutionarily linked. The evolution of body size in Madagascar's microhylids has been more dynamic than previously understood, and future studies will hopefully shed light on the interplay between ecology and evolution of these remarkably diverse frogs

Microbiota Modulate Behavioral and Physiological Abnormalities Associated with Neurodevelopmental Disorders

Neurodevelopmental disorders, including autism spectrum disorder (ASD), are defined by core behavioral impairments; however, subsets of individuals display a spectrum of gastrointestinal (GI) abnormalities. We demonstrate GI barrier defects and microbiota alterations in the maternal immune activation (MIA) mouse model that is known to display features of ASD. Oral treatment of MIA offspring with the human commensal Bacteroides fragilis corrects gut permeability, alters microbial composition, and ameliorates defects in communicative, stereotypic, anxiety-like and sensorimotor behaviors. MIA offspring display an altered serum metabolomic profile, and B. fragilis modulates levels of several metabolites. Treating naive mice with a metabolite that is increased by MIA and restored by B. fragilis causes certain behavioral abnormalities, suggesting that gut bacterial effects on the host metabolome impact behavior. Taken together, these findings support a gut-microbiome-brain connection in a mouse model of ASD and identify a potential probiotic therapy for GI and particular behavioral symptoms in human neurodevelopmental disorders

Endomembrane targeting of human OAS1 p46 augments antiviral activity

Many host RNA sensors are positioned in the cytosol to detect viral RNA during infection. However, most positive-strand RNA viruses replicate within a modified organelle co-opted from intracellular membranes of the endomembrane system, which shields viral products from cellular innate immune sensors. Targeting innate RNA sensors to the endomembrane system may enhance their ability to sense RNA generated by viruses that use these compartments for replication. Here, we reveal that an isoform of oligoadenylate synthetase 1, OAS1 p46, is prenylated and targeted to the endomembrane system. Membrane localization of OAS1 p46 confers enhanced access to viral replication sites and results in increased antiviral activity against a subset of RNA viruses including flaviviruses, picornaviruses, and SARS-CoV-2. Finally, our human genetic analysis shows that the OAS1 splice-site SNP responsible for production of the OAS1 p46 isoform correlates with protection from severe COVID-19. This study highlights the importance of endomembrane targeting for the antiviral specificity of OAS1 and suggests that early control of SARS-CoV-2 replication through OAS1 p46 is an important determinant of COVID-19 severity

Prefrontal and anterior cingulate cortex abnormalities in Tourette Syndrome: evidence from voxel-based morphometry and magnetization transfer imaging

<p>Abstract</p> <p>Background</p> <p>Pathophysiological evidence suggests an involvement of fronto-striatal circuits in Tourette syndrome (TS). To identify TS related abnormalities in gray and white matter we used optimized voxel-based morphometry (VBM) and magnetization transfer imaging (MTI) which are more sensitive to tissue alterations than conventional MRI and provide a quantitative measure of macrostructural integrity.</p> <p>Methods</p> <p>Volumetric high-resolution anatomical T1-weighted MRI and MTI were acquired in 19 adult, unmedicated male TS patients without co-morbidities and 20 age- and sex-matched controls on a 1.5 Tesla neuro-optimized GE scanner. Images were pre-processed and analyzed using an optimized version of VBM in SPM2.</p> <p>Results</p> <p>Using VBM, TS patients showed significant decreases in gray matter volumes in prefrontal areas, the anterior cingulate gyrus, sensorimotor areas, left caudate nucleus and left postcentral gyrus. Decreases in white matter volumes were detected in the right inferior frontal gyrus, the left superior frontal gyrus and the anterior corpus callosum. Increases were found in the left middle frontal gyrus and left sensorimotor areas. In MTI, white matter reductions were seen in the right medial frontal gyrus, the inferior frontal gyrus bilaterally and the right cingulate gyrus. Tic severity was negatively correlated with orbitofrontal structures, the right cingulate gyrus and parts of the parietal-temporal-occipital association cortex bilaterally.</p> <p>Conclusion</p> <p>Our MRI <it>in vivo </it>neuropathological findings using two sensitive and unbiased techniques support the hypothesis that alterations in frontostriatal circuitries underlie TS pathology. We suggest that anomalous frontal lobe association and projection fiber bundles cause disinhibition of the cingulate gyrus and abnormal basal ganglia function.</p

Assessing the presence of shared genetic architecture between Alzheimer's disease and major depressive disorder using genome-wide association data

We are grateful to the families and individuals who took part in the GS:SFHS and UKB studies, and to all those involved in participant recruitment, data collection, sample processing and QC, including academic researchers, clinical staff, laboratory technicians, clerical workers, IT staff, statisticians and research managers. This work is supported by the Wellcome Trust through a Strategic Award, reference 104036/Z/ 14/Z. We acknowledge with gratitude the financial support received from the Dr Mortimer and Theresa Sackler Foundation. This research has been conducted using the GS:SFHS and UK Biobank (project #4844) resources. GS:SFHS received core funding from the Chief Scientist Office of the Scottish Government Health Directorates [CZD/16/6] and the Scottish Funding Council [HR03006]. UKB was established using funding from the Wellcome Trust, Medical Research Council, the Scottish Government Department of Health, and the Northwest Regional Development Agency. DJP, IJD, TCR and AMM are members of the University of Edinburgh Centre for Cognitive Ageing and Cognitive Epidemiology, part of the cross council Lifelong Health and Wellbeing Initiative (MR/K026992/1). TCR is supported by Alzheimer's Scotland, through the Marjorie MacBeath bequest. Funding from the Biotechnology and Biological Sciences Research Council and Medical Research Council is gratefully acknowledged. We are grateful for the use of summary data from the International Genomics of Alzheimer's Project and the Major Depressive Disorder working group of the Psychiatric Genomics Consortium.Peer reviewedPublisher PD